﻿CREATE TRIGGER [dbo].[UserApplication_Housekeeping_InsUpdTrg]
    ON [dbo].[UserApplication]
    FOR INSERT, UPDATE
    AS BEGIN 

UPDATE UserApplication 
        SET UserApplication.RevDt = GETDATE(), 
            UserApplication.RevUid = SUSER_SNAME(), 
            UserApplication.RevMdlName = APP_NAME() 
    FROM UserApplication t INNER JOIN inserted i ON t.ID = i.ID 

END

